﻿namespace Snake.SQL
{
    static class SQLStrings
    {
        public const string Select = "SELECT";
        public const string Delete = "DELETE";
        public const string Insert = "INSERT";
        public const string Update = "UPDATE";
        public const string Into = "INTO";
        public const string IN = "IN";
        public const string Values = "VALUES";
        public const string Where = "WHERE";
        public const string Distinct = "DISTINCT";
        public const string Join = "JOIN";
        public const string LeftJoin = "LEFT JOIN";
        public const string Top = "TOP";
        public const string Like = "LIKE";
        public const string From = "FROM";
        public const string As = "AS";
        public const string On = "ON";
        public const string Null = "NULL";        
        public const string Is = "IS";
        public const string Or = "OR";
        public const string And = "AND";
        public const string Not = "NOT";
        public const string LessThan = "<";
        public const string GreaterThan = ">";
        public const string Equal = "=";
        public const string NotEqual = "<>";
        public const string GreaterThanOrEqual = ">=";
        public const string LessThanOrEqual = "<=";
        public const string Ascending = "ASC";
        public const string Descending = "DESC";
        public const string OrderBy = "ORDER BY";
        public const string ROW_NUMBER = "ROW_NUMBER";//产生行号
        public const string Over = "OVER";
        public const string Set = "SET";
        public const string NoLock = "(NOLOCK)";

        //函数
        public const string SCOPE_IDENTITY = "SCOPE_IDENTITY()";
        public const string Declare = "DECLARE";

        //类型

        public const string Int = "INT";

    }
}